﻿using System;
using System.Data;
using System.Collections.Generic;

using Com.Framework.Data;
using Com.Library.DB;

namespace Com.Library.DB.Board
{
	internal class ArticleGetInfo : DBDataReader<DataEntity, ArticleEntity>
	{
		public ArticleGetInfo()
			: base(new ConnectionString(), "TSP_Article_GetInfo")
		{
		}

		protected override void ParameterInitialize()
        {
            AddParameter("n4ArticleSN", SqlDbType.Int, 4, SqlDataInOut.Input);
            AddParameter("n1BoardSN", SqlDbType.TinyInt, 1, SqlDataInOut.Output);
			AddParameter("n4CategoryNo", SqlDbType.Int, 4, SqlDataInOut.Output);
            AddParameter("strTitle", SqlDbType.NVarChar, 400, SqlDataInOut.Output);
            AddParameter("strContent", SqlDbType.NVarChar, -1, SqlDataInOut.Output);
            AddParameter("strJSONData", SqlDbType.NVarChar, -1, SqlDataInOut.Output);
            AddParameter("strFileUrl", SqlDbType.VarChar, 1000, SqlDataInOut.Output);
            AddParameter("n4ManagerSNWriter", SqlDbType.Int, 4, SqlDataInOut.Output);
            AddParameter("strUserID", SqlDbType.VarChar, 50, SqlDataInOut.Output);
            AddParameter("dtCreatedDate", SqlDbType.DateTime, 8, SqlDataInOut.Output);
            AddParameter("dtModifiedDate", SqlDbType.DateTime, 8, SqlDataInOut.Output);
            AddParameter("n4ReadCount", SqlDbType.Int, 4, SqlDataInOut.Output);
            AddParameter("isRequireAdjacentInfo", SqlDbType.Bit, 1, SqlDataInOut.Input);
			AddParameter("isUpdateReadCount", SqlDbType.Bit, 1, SqlDataInOut.Input);
            AddParameter("strTitle_Search", SqlDbType.NVarChar, 400, SqlDataInOut.Input);
            AddParameter("n4ArticleSN_next", SqlDbType.Int, 4, SqlDataInOut.Output);
            AddParameter("n4ArticleSN_prev", SqlDbType.Int, 4, SqlDataInOut.Output);
            AddParameter("strTitle_next", SqlDbType.NVarChar, 400, SqlDataInOut.Output);
            AddParameter("strTitle_prev", SqlDbType.NVarChar, 400, SqlDataInOut.Output);
        }
	}
}